A RCHITECTURE - C ONSCIOUS D ATABASE S YSTEMS by Anastassia Ailamaki A dissertation
نویسنده
چکیده
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii Chapter 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.1 A Model for Commercial Database Execution Time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.2 PAX: A Cache-Conscious Data Page Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 1.3 Porting Shore on Four Systems: Where Is My Dream Machine? . . . . . . . . . . . . . . . . . . . . . . . . 8 1.4 A Note on Methodology: Measurement Vs. Simulation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 1.5 Thesis Organization 11 Chapter 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2.1 Previous work . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 2.2 Query Execution on Modern Processors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 2.2.1 Query Execution Time: A Processor Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 2.2.2 Significance of the stall components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.2.3 Database workload . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 2.3 Experimental Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 2.3.1 The hardware platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 2.3.2 The software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 2.3.3 Measurement tools and methodology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
منابع مشابه
Processor Performance of Selection Queries
Microsoft Corporation, 1999. All Rights Reserved. 1 Microsoft Confidential
متن کاملHot DB'02 course project reports : hot topics in database systems, fall 2002
This technical report contains eight final project reports contributed by ten participants in "Hot Topics in Database Systems," a CMU advanced graduate course offered by Professor Anastassia Ailamaki in Fall 2002. The course covers advanced research issues in modern database system design through paper presentations and discussion. In Fall 2002, topics included query optimization, data stream a...
متن کاملProfiling the Resource Usage of OLTP Database Queries
This technical report contains eight final project reports contributed by ten participants in “Hot Topics in Database Systems,” a CMU advanced graduate course offered by Professor Anastassia Ailamaki in Fall 2002. The course covers advanced research issues in modern database system design through paper presentations and discussion. In Fall 2002, topics included query optimization, data stream a...
متن کامل